Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL
1) Aggregate Functions
2) Backup Load
3) Command Mysql
4) Cursor
5) Data Type
6) Database
7) Date Time
8) Engine
9) Event
10) Flow Control
11) Fulltext Search
12) Function
13) Geometric
14) Insert Delete Update
15) Internationalization
16) Join
17) Key
18) Math
19) Procedure Function
20) Regular Expression
21) Select Clause
22) String
23) Table Index
24) Transaction
25) Trigger
26) User Permission
27) View
28) Where Clause
29) XML

Internationalization
1) _utf8 modifier
2) ALTER TABLE employee MODIFY employee VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_german2_ci
3) Alter table to change the collate setting
4) Cast COLLATE
5) Change collate for database
6) Change the character set name and collate name for database
7) Change the Character Set of All Text Columns
8) Changing the Character Set
9) CHARACTER SET latin1, CHARACTER SET hp8
10) CHARACTER SET utf8 for column definition
11) Character setting for char type column
12) Check the character set
13) Check the character set name and description
14) Check the character set settings
15) Check the collation name
16) Check the default character set name
17) Check utf8 collation name in INFORMATION_SCHEMA COLLATIONS
18) COLLATE latin1_danish_ci
19) COLLATE sort operator allows you ro specify a collation in your expression
20) COLLATE utf8_romanian_ci for column definition
21) CONVERT(expression USING character set)
22) CREATE DATABASE statement specifies the character set and collation
23) Create database with character set and collate
24) ERROR 1267 (HY000)
25) Exporting with the SELECT INTO OUTFILE Statement
26) Get CHARSET
27) Get collation
28) Get the charset and collation information
29) List all collation utf8 related
30) MySQL Character Set Variables
31) Optionally, you can specify a default character set and sort order
32) ORDER BY a column COLLATE latin1_swedish_ci
33) ORDER BY and COLLATE latin1_german2_ci
34) Order by collate
35) ORDER BY CONVERT(firstname USING utf8) COLLATE utf8_polish_ci
36) SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_general_ci
37) SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_german1_ci
38) SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_swedish_ci
39) SELECT firstname FROM employee ORDER BY firstname COLLATE utf8_general_ci
40) Set COLLATE=latin1_german1_ci
41) Set default character during table definition
42) Set DEFAULT CHARSET=latin1
43) Set the character set and collate for a table
44) Specifying the Character Set of a Character String (Cast Operator)
45) Table with default chartset= latin1
46) The CHARSET() function identifies the character set used for a specified string
47) To change the character set to latin1 for the BookSales database, use the following ALTER DATABASE statement
48) To process UTF-8 data